prompt PL/SQL Developer import file
prompt Created on Friday, August 29, 2014 by dananjayadod
set feedback off
set define off
prompt Disabling triggers for CUSTOMER...
alter table CUSTOMER disable all triggers;
prompt Disabling triggers for FORWARDER...
alter table FORWARDER disable all triggers;
prompt Disabling triggers for PORT...
alter table PORT disable all triggers;
prompt Disabling triggers for CUSTOMER_ORDER...
alter table CUSTOMER_ORDER disable all triggers;
prompt Disabling triggers for PART...
alter table PART disable all triggers;
prompt Disabling triggers for ORDER_LINE...
alter table ORDER_LINE disable all triggers;
prompt Disabling foreign key constraints for CUSTOMER_ORDER...
alter table CUSTOMER_ORDER disable constraint CUSTOMER_ORDER_CUSTOMER_FK;
alter table CUSTOMER_ORDER disable constraint CUSTOMER_ORDER_FORWARDER_FK;
alter table CUSTOMER_ORDER disable constraint CUSTOMER_ORDER_PORT_FK;
alter table CUSTOMER_ORDER disable constraint CUSTOMER_ORDER_PORT_FK2;
prompt Disabling foreign key constraints for ORDER_LINE...
alter table ORDER_LINE disable constraint ORDER_LINE_CUSTOMER_ORDER_FK;
alter table ORDER_LINE disable constraint ORDER_LINE_PART_FK;
prompt Loading CUSTOMER...
insert into CUSTOMER (CUSTOMER_ID, NAME, EMAIL, PHONE, ADDRESS, COUNTRY)
values (305128, 'Maersk Drilling Services AS', 'dananjayadod@gmail.com', '0716580390', 'No 135, Stavenger, Denmark.', 'DK');
commit;
prompt 1 records loaded
prompt Loading FORWARDER...
insert into FORWARDER (FORWARDER_ID, NAME)
values ('DHL', 'DHL Shipping Co');
commit;
prompt 1 records loaded
prompt Loading PORT...
insert into PORT (PORT_ID, PORT_NAME, LAT, long)
values ('ROT', 'Rotterdam Netherlands', null, null);
insert into PORT (PORT_ID, PORT_NAME, LAT, long)
values ('TAJ', 'Tianjin China', null, null);
commit;
prompt 2 records loaded
prompt Loading CUSTOMER_ORDER...
insert into CUSTOMER_ORDER (ORDER_ID, CUSTOMER_ID, AUTHORIZOR, PRIORITY, WANTED_DELIVERY_DATE, DELIVERY_ADDRESS, FORWARDER_ID, SOURCE, DESTINATION, STATUS)
values (1001, 305128, null, 1, to_date('23-08-2014', 'dd-mm-yyyy'), 'China Town, Singapore', 'DHL', 'TAJ', 'ROT', 'Authorized');
insert into CUSTOMER_ORDER (ORDER_ID, CUSTOMER_ID, AUTHORIZOR, PRIORITY, WANTED_DELIVERY_DATE, DELIVERY_ADDRESS, FORWARDER_ID, SOURCE, DESTINATION, STATUS)
values (1002, 305128, null, null, to_date('31-12-2014', 'dd-mm-yyyy'), 'London, England', 'DHL', 'ROT', 'TAJ', 'Planned');
insert into CUSTOMER_ORDER (ORDER_ID, CUSTOMER_ID, AUTHORIZOR, PRIORITY, WANTED_DELIVERY_DATE, DELIVERY_ADDRESS, FORWARDER_ID, SOURCE, DESTINATION, STATUS)
values (1000, 305128, null, null, to_date('20-08-2014', 'dd-mm-yyyy'), 'China Town', 'DHL', 'ROT', 'TAJ', 'Planned');
insert into CUSTOMER_ORDER (ORDER_ID, CUSTOMER_ID, AUTHORIZOR, PRIORITY, WANTED_DELIVERY_DATE, DELIVERY_ADDRESS, FORWARDER_ID, SOURCE, DESTINATION, STATUS)
values (1004, 305128, null, 1, to_date('30-08-2014', 'dd-mm-yyyy'), 'Netharlands', null, 'TAJ', 'ROT', 'Planned');
insert into CUSTOMER_ORDER (ORDER_ID, CUSTOMER_ID, AUTHORIZOR, PRIORITY, WANTED_DELIVERY_DATE, DELIVERY_ADDRESS, FORWARDER_ID, SOURCE, DESTINATION, STATUS)
values (1123, 305128, null, null, to_date('30-08-2014', 'dd-mm-yyyy'), 'Canada', null, 'TAJ', 'ROT', 'Planned');
insert into CUSTOMER_ORDER (ORDER_ID, CUSTOMER_ID, AUTHORIZOR, PRIORITY, WANTED_DELIVERY_DATE, DELIVERY_ADDRESS, FORWARDER_ID, SOURCE, DESTINATION, STATUS)
values (1005, 305128, null, 1, to_date('30-08-2014', 'dd-mm-yyyy'), 'Washington DC', 'DHL', 'ROT', 'TAJ', 'Planned');
insert into CUSTOMER_ORDER (ORDER_ID, CUSTOMER_ID, AUTHORIZOR, PRIORITY, WANTED_DELIVERY_DATE, DELIVERY_ADDRESS, FORWARDER_ID, SOURCE, DESTINATION, STATUS)
values (1010, 305128, null, 2, to_date('06-09-2014', 'dd-mm-yyyy'), 'Cape Town, RSA', 'DHL', 'ROT', 'TAJ', 'Planned');
insert into CUSTOMER_ORDER (ORDER_ID, CUSTOMER_ID, AUTHORIZOR, PRIORITY, WANTED_DELIVERY_DATE, DELIVERY_ADDRESS, FORWARDER_ID, SOURCE, DESTINATION, STATUS)
values (1007, 305128, null, 1, to_date('30-08-2014', 'dd-mm-yyyy'), 'LK, Colombo', 'DHL', 'ROT', 'TAJ', 'Planned');
commit;
prompt 8 records loaded
prompt Loading PART...
insert into PART (PART_ID, PART_DESC, UNIT_COST, VOLUME, WEIGHT)
values (100155, 'K1 R1A', 125, 100, 25);
insert into PART (PART_ID, PART_DESC, UNIT_COST, VOLUME, WEIGHT)
values (100200, 'K1 R1B', 290, 100, 24);
commit;
prompt 2 records loaded
prompt Loading ORDER_LINE...
insert into ORDER_LINE (ORDER_ID, LINE_ID, PART_ID, QUANTITY, NET_AMOUNT, TAX_AMOUNT, GROSS_AMOUNT)
values (1001, 21, 100155, 1, 125, 15.625, 140.625);
insert into ORDER_LINE (ORDER_ID, LINE_ID, PART_ID, QUANTITY, NET_AMOUNT, TAX_AMOUNT, GROSS_AMOUNT)
values (1002, 10, 100155, 6, 750, 93.75, 843.75);
insert into ORDER_LINE (ORDER_ID, LINE_ID, PART_ID, QUANTITY, NET_AMOUNT, TAX_AMOUNT, GROSS_AMOUNT)
values (1002, 11, 100155, 56, 7000, 875, 7875);
insert into ORDER_LINE (ORDER_ID, LINE_ID, PART_ID, QUANTITY, NET_AMOUNT, TAX_AMOUNT, GROSS_AMOUNT)
values (1007, 8, 100155, 134, 16750, 2093.75, 18843.75);
insert into ORDER_LINE (ORDER_ID, LINE_ID, PART_ID, QUANTITY, NET_AMOUNT, TAX_AMOUNT, GROSS_AMOUNT)
values (1002, 19, 100155, 12, 1500, 187.5, 1687.5);
insert into ORDER_LINE (ORDER_ID, LINE_ID, PART_ID, QUANTITY, NET_AMOUNT, TAX_AMOUNT, GROSS_AMOUNT)
values (1002, 20, 100155, 123, 15375, 1921.875, 17296.875);
insert into ORDER_LINE (ORDER_ID, LINE_ID, PART_ID, QUANTITY, NET_AMOUNT, TAX_AMOUNT, GROSS_AMOUNT)
values (1007, 14, 100200, 12, 3480, 435, 3915);
insert into ORDER_LINE (ORDER_ID, LINE_ID, PART_ID, QUANTITY, NET_AMOUNT, TAX_AMOUNT, GROSS_AMOUNT)
values (1007, 15, 100200, 1234, 357860, 44732.5, 402592.5);
insert into ORDER_LINE (ORDER_ID, LINE_ID, PART_ID, QUANTITY, NET_AMOUNT, TAX_AMOUNT, GROSS_AMOUNT)
values (1001, 16, 100155, 1, 125, 15.625, 140.625);
insert into ORDER_LINE (ORDER_ID, LINE_ID, PART_ID, QUANTITY, NET_AMOUNT, TAX_AMOUNT, GROSS_AMOUNT)
values (1002, 17, 100155, 12, 1500, 187.5, 1687.5);
insert into ORDER_LINE (ORDER_ID, LINE_ID, PART_ID, QUANTITY, NET_AMOUNT, TAX_AMOUNT, GROSS_AMOUNT)
values (1001, 5, 100155, 123, 15375, 1921.875, 17296.875);
insert into ORDER_LINE (ORDER_ID, LINE_ID, PART_ID, QUANTITY, NET_AMOUNT, TAX_AMOUNT, GROSS_AMOUNT)
values (1002, 12, 100200, 12, 3480, 435, 3915);
insert into ORDER_LINE (ORDER_ID, LINE_ID, PART_ID, QUANTITY, NET_AMOUNT, TAX_AMOUNT, GROSS_AMOUNT)
values (1004, 22, 100155, 1, 125, 15.625, 140.625);
insert into ORDER_LINE (ORDER_ID, LINE_ID, PART_ID, QUANTITY, NET_AMOUNT, TAX_AMOUNT, GROSS_AMOUNT)
values (1001, 23, 100155, 12, 1500, 187.5, 1687.5);
insert into ORDER_LINE (ORDER_ID, LINE_ID, PART_ID, QUANTITY, NET_AMOUNT, TAX_AMOUNT, GROSS_AMOUNT)
values (1001, 3, 100155, 124, 15500, 1937.5, 17437.5);
commit;
prompt 15 records loaded
prompt Enabling foreign key constraints for CUSTOMER_ORDER...
alter table CUSTOMER_ORDER enable constraint CUSTOMER_ORDER_CUSTOMER_FK;
alter table CUSTOMER_ORDER enable constraint CUSTOMER_ORDER_FORWARDER_FK;
alter table CUSTOMER_ORDER enable constraint CUSTOMER_ORDER_PORT_FK;
alter table CUSTOMER_ORDER enable constraint CUSTOMER_ORDER_PORT_FK2;
prompt Enabling foreign key constraints for ORDER_LINE...
alter table ORDER_LINE enable constraint ORDER_LINE_CUSTOMER_ORDER_FK;
alter table ORDER_LINE enable constraint ORDER_LINE_PART_FK;
prompt Enabling triggers for CUSTOMER...
alter table CUSTOMER enable all triggers;
prompt Enabling triggers for FORWARDER...
alter table FORWARDER enable all triggers;
prompt Enabling triggers for PORT...
alter table PORT enable all triggers;
prompt Enabling triggers for CUSTOMER_ORDER...
alter table CUSTOMER_ORDER enable all triggers;
prompt Enabling triggers for PART...
alter table PART enable all triggers;
prompt Enabling triggers for ORDER_LINE...
alter table ORDER_LINE enable all triggers;
set feedback on
set define on
prompt Done.
